Practice Set 4
We'll cover the following
Practice Set 4#
The database relationship model is reprinted below.
Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/quiz.sh and wait for the MySQL prompt to start-up.
Write and execute queries for the following questions:
-
Write a query to display the average collection in millions of producers who have produced more than one movie.
Expected Result:
| Producer_Name | Average_Collection_In_Millions |
|---|---|
| producer 1 | amount |
| producer 2 | amount |
| … | … |
| … | … |
| producer n | amount |
-
Find all those actors who have not worked with producer Ryan Seacrest.
Expected Result:
| Actors_Who_Not_Worked_With_Ryan_Seacrest |
|---|
| actor 1 |
| actor 2 |
| … |
| … |
| actor n |
-
Populate a table DigitalActivityTrack with the last digital activity of each actor along with the asset type on which the activity occurred.
Expected Result:
| Actor_Name | Digital_Asset | Last_Updated_At |
|---|---|---|
| actor 1 | asset name | update time |
| actor 2 | asset name | update time |
| … | … | … |
| … | … | … |
| actor n | asset name | update time |
-
Find the actor with the third lowest Net Worth in Millions without using the LIMIT clause
Expected Result:
| Actor_Name | 3rd_Lowest_Net_Worth_In_Millions |
|---|---|
| actor | amount |
-
Write a query to display actors along with a comma separated list of their digital assets.
Expected Result:
| Actor_Name | Digital_Assets |
|---|---|
| actor1 1 | asset1, asset2, … |
| actor 2 | asset1, asset2, … |
| … | … |
| … | … |
| actor n | asset1, asset2, … |
